<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-family:'DejaVu Sans'; font-size:11pt; font-weight:400; font-style:normal;">
<p style=" margin-top:0px; margin-bottom:10px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; font-weight:600;">VBA Excel. Привязка события к элементу управления</span></p>
<p style=" margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; font-style:italic;">Привязка события к программно созданному элементу управления формы в VBA Excel на примере привязки события SpinButton_Change к счетчику и события CommandButton_Click к кнопке.</span></p>
<p style=" margin-top:32px; margin-bottom:6px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#fafafa;"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; font-weight:600; color:#333333;">Содержание</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a href="https://vremya-ne-zhdet.ru/vba-excel/privyazka-sobytiya-k-elementu-upravleniya/#Privazka_sobytia_k_elementu_upravlenia"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; text-decoration: underline; color:#0000ff;">1. Привязка события к элементу управления</span></a></p>
<p style=" margin-top:2px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a href="https://vremya-ne-zhdet.ru/vba-excel/privyazka-sobytiya-k-elementu-upravleniya/#Primer_privazki_sobytij_k_obektam"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; text-decoration: underline; color:#0000ff;">2. Пример привязки событий к объектам</span></a></p>
<p style=" margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="Privazka_sobytia_k_elementu_upravlenia"></a><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; font-weight:600;">П</span><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; font-weight:600;">ривязка события к элементу управления</span></p>
<p style=" margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a href="https://vremya-ne-zhdet.ru/vba-excel/metod-controls-add/"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; text-decoration: underline; color:#0000ff;">Динамически</span></a><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;"> созданные элементы управления пользовательской формы никак не реагируют на свойственные им события. Чтобы это изменить, необходимо объявить переменные, предназначенные для создания этих элементов управления,</span></p>
<ol style="margin-top: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; -qt-list-indent: 1;"><li style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; background-color:#c8fbc8;" style=" margin-top:10px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">с типом, описывающим создаваемый элемент управления;</li>
<li style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;" style=" margin-top:10px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">с ключевым словом WithEvents, которое указывает, что создаваемый объект должен быть связан со всеми присущими ему событиями.</li></ol>
<p style=" margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="aswift_1_host"></a><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;">П</span><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;">роцедуры событий для программно созданных элементов управления должны быть заранее приготовлены в </span><a href="https://vremya-ne-zhdet.ru/vba-excel/modul-protsedura-forma/"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; text-decoration: underline; color:#0000ff;">модуле</span></a><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;"> пользовательской формы.</span></p>
<p style=" margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;">Синтаксис процедур событий для динамически создаваемых элементов управления:</span></p>
<p style="-qt-paragraph-type:empty; margin-top:12px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; line-height:15px; font-family:'Verdana,Arial,sans'; font-size:7.8pt; font-weight:496; background-color:#fdfdfd;"><br /></p>
<table border="0" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;" cellspacing="2" cellpadding="0">
<tr>
<td bgcolor="#dfefff" style=" vertical-align:top; padding-left:0; padding-right:0; padding-top:0; padding-bottom:0;">
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdf4616749915"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">1</span></p></td>
<td style=" vertical-align:top; padding-left:0; padding-right:0; padding-top:0; padding-bottom:0;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdf4616749915-1"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">S</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">ub</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#000000;">ИмяПеременной_Событие</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">()</span></p></td></tr></table>
<p style=" margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="Primer_privazki_sobytij_k_obektam"></a><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; font-weight:600;">П</span><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt; font-weight:600;">ример привязки событий к объектам</span></p>
<p style=" margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;">Пример привязки события SpinButton_Change к программно созданному счетчику (SpinButton) и привязки события CommandButton_Click к динамически созданной кнопке (CommandButton):</span></p>
<p style="-qt-paragraph-type:empty; margin-top:12px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; line-height:15px; font-family:'Verdana,Arial,sans'; font-size:7.8pt; font-weight:496; background-color:#fdfdfd;"><br /></p>
<table border="0" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;" cellspacing="2" cellpadding="0">
<tr>
<td bgcolor="#dfefff" style=" vertical-align:top; padding-left:0; padding-right:0; padding-top:0; padding-bottom:0;">
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">1</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">2</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">3</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">4</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">5</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">6</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">7</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">8</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">9</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">10</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">11</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">12</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">13</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">14</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">15</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">16</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">17</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">18</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">19</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">20</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">21</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">22</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">23</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">24</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">25</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">26</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">27</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">28</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">29</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">30</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">31</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">32</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">33</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">34</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#5499de;">35</span></p>
<p align="center" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#c8e1fa;"><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#317cc5; background-color:#c8e1fa;">36</span></p></td>
<td style=" vertical-align:top; padding-left:0; padding-right:0; padding-top:0; padding-bottom:0;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-1"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">O</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">ption</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">Explicit</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-2"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#000000; background-color:#f7f7f7;"> </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-3"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">D</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">im</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">myTxt </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">As</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">Control</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-4"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">P</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">rivate</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">WithEvents</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">mySpinB </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">As</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">SpinButton</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-5"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">P</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">rivate</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">WithEvents</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">myBtn </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">As</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">CommandButton</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-6"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#000000; background-color:#f7f7f7;"> </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-7"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">P</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">rivate</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">Sub</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">UserForm_Initialize</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">()</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-8"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">With</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">Me</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-9"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">Set</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">mySpinB</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Controls</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">Add</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">(</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#008000;">&quot;Forms.SpinButton.1&quot;</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">)</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-10"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">Set</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">myTxt</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Controls</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">Add</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">(</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#008000;">&quot;Forms.TextBox.1&quot;</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">)</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-11"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">Set</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">myBtn</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Controls</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">Add</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">(</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#008000;">&quot;Forms.CommandButton.1&quot;</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">)</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-12"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">End</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">With</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-13"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">With</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#000000;">myTxt</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-14"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Left</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#ce0000;">30</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-15"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Top</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#ce0000;">10</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-16"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Text</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#008000;">&quot;0&quot;</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-17"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">End</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">With</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-18"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">With</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#000000;">mySpinB</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-19"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Left</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#ce0000;">10</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-20"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Top</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#ce0000;">10</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-21"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">End</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">With</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-22"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">With</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#000000;">myBtn</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-23"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Left</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#ce0000;">30</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-24"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Top</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#ce0000;">40</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-25"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">       </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Caption</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#008000;">&quot;Обнулить&quot;</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-26"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">End</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">With</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-27"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">E</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">nd</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">Sub</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-28"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#000000; background-color:#f7f7f7;"> </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-29"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">S</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">ub</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">mySpinB_Change</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">()</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-30"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">myTxt</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Text</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">mySpinB</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">Value</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-31"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">E</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">nd</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">Sub</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-32"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#000000; background-color:#f7f7f7;"> </span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-33"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">S</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">ub</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#004ed0;">myBtn_Click</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">()</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-34"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">myTxt</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Text</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#008000;">&quot;0&quot;</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-35"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;">   </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">mySpinB</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#333333;">.</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#002d7a;">Value</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> = </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#ce0000;">0</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; background-color:#f7f7f7;"><a name="urvanov-syntax-highlighter-64fa2fa74bdff220722526-36"></a><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">E</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">nd</span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#006fe0;"> </span><span style=" font-family:'inherit'; font-size:7.8pt; font-weight:496; color:#800080;">Sub</span></p></td></tr></table>
<p style=" margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="aswift_2_host"></a><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;">В</span><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;">нешний вид пользовательской формы с динамически созданными элементами управления (SpinButton, TextBox и CommandButton) с размерами по умолчанию в VBA Excel 2016:</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; font-family:'MS Shell Dlg 2'; font-size:7.8pt;"><br /></p>
<p style=" margin-top:0px; margin-bottom:30px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'MS Shell Dlg 2'; font-size:7.8pt;">Значение счетчика автоматически копируется в текстовое поле, а кнопка «Обнулить» обнуляет и счетчик, и значение в текстовом поле.</span></p></body></html>